-
Re: INDEX and MATCH across two sheets: a detailed explanation
Wow! Thanks so much @Brett Wyrick for coming out of hibernation to help out! So, I went through each of your possible solutions and I will give some feedback: A. Check Data Types: I can confirm that …1 · -
Index/Match across 3 sheets resulting in #invalid value
Hi all, I have lots of experience with Index/Match in Excel and Smartsheet and this one has stumped me and I can't figure out why. Here's the scoop: I have 1 sheet (Sheet 1) where I import an xlsx do…1 ·